In this investigation, job listings for Germany are analyzed to answer the following questions:
The data consists of 2 datasets:
Job Listings: Title, City, Industry and Company Size
Salaries: Job Title, Industry and Company Size, Low, Median and High Base Salary
Approx. 97% of the job listings have been posted between 2019-10-11 and 2019-11-10. Based on the fact that the data was gathered on the 10th of December 2019, most listings are not older than 2 months. The remaining listings, especially the ones from 2018 and earlier 2019 might be outdated or a kind of permanent listings.
For approx. 90% of the job listings a normalized job title could be assigned. The titles with the highest frequency are Software Engineer and Data engineer. Project Manager, Data Scientist, Product Manager, Business Analyst, Data Analyst, Researcher, Product Owner and Machine Learning Engineer will be considered be for further investigations. The Engineering Manager and Scrum Master job listing frequencies are outliers. The normalized job titles do not have information about the job level, i.e. there is no differentiation between interns, entries or seniors.
For roughly 80% of the job listings records the company size in terms of number of employees known. Those job listings are well distributed among all company sizes. Companies with more than 10000+ employees provide the most job listings (25%). The two smallest companies sizes have the next highest shares with each almost 20%.
The city is known for 96% of the job listings. The top 10 out of 344 unique locations are representing 65% of the job listings that have a location provided. 55% of the records that have a location are within the top 5 locations. Berlin has the highest frequency with more than 25%. This is more than twice of the job listings for the location München (Munich) with roughly 12%. The third top location Frankfurt am Main, the forth Hamburg and fifth Köln (Cologne) have roughly half as much of listings as München. The further investigation will focus just on the top 5 cities.
For only 64% of the job listings the employer industry is known. The top 10 out of 91 unique industries are representing 60% of the job listings that have an industry provided. 47% of the records that have an industry are within the top 5 industries. The Internet industry has the highest frequency with more than 16%. It's remarkable that the top 4 industries are IT-related and sum up to a share of approx. 40.5%. The further investigation will focus just on the top 5 industries.
21% of the records have a normalized job title. Out of this, roughly 49% of the reported salaries are Software Engineers. This is more than twice of the second largest frequency share representing Project Manager (19%). The top 5 cover 97% of the frequency share. The remaining 3% share will not be considered for further investigations. Especially, the job titles Data Analyst, Data Scientist and Data Engineer had high frequencies for job listings, but have almost no salary reports.
For almost each of the top 5 normalized job titles large companies with more than 10,000 employees seem to have the largest share of job listings. Only for Product Owner the share of such large companies is clearly smaller. The smallest companies with less than 201 employees have often the second largest share of job listings. It's eyecatching that small companies count more job listings for Product Owner than large companies. Software Engineers and Data Engineers are the most listed among all company sizes.
Illustration ▼
Especially in Berlin, but also in München (Munich) and Köln (Cologne) Software Engineer listings have the highest share. For Frankfurt am Main Business Analysts and for Hamburg Data Scientists are most listed. The second largest shares for all locations, besides Berlin, are Data Engineer listings. In Berlin, it is the third largest share, which is still larger than the largest share of listings of other locations. The second largest share in Berlin by far is Product Manager. This is unusual compared to the large shares of other location.
Job listings of Software Engineers have the largest share in Internet, Computer Hardware & Software and Enterprise Software & Network Solutions by far. In IT Services and Consulting industry it's a large share, but not the largest. Instead Data Engineers are most listed for those industries. The second largest share in Internet industry by far is Product Manager. This is unusual compared to the large shares of other industries.
5 times more salaries have been reported for Software Engineers (67%) compared to the second largest number of reported salaries for Project Manager (13%). For Business Analyst 11%, for Product Manager 5% and 3% for Researcher have been reported.
The highest average salaries are reported for Product Managers by far. The next higher average salaries are for Project Managers followed by Software Engineers by only a slight difference. The mean median salary of those jobs titles is approx. at the same level as the low salary of Product Managers. Business Analyst average salaries are lower than Software Engineers. The mean high salary of Business Analysts is approx. at the same level as the mean median average salaries of Software Engineers. Researcher have by far the lowest salaries reported.
The most listings for each Company Size are provided by the following combinations:
Continue ▼
Further observations:
Illustration ▼
The most listings for each Industry are provided by the following combinations:
Continue ▼
Further observations:
Illustration ▼
The top 5 job title and company size combinations with the largest count of reported salaries are:
Continue ▼
Further observations:
Illustration ▼
Among the combinations of the top 5 job titles and top 5 industries, the ranking of the largest number of reported salaries is as follows:
Continue ▼
Missing reported salaries:
Illustration ▼
The highest median of the reported median salaries is represented by each of the following top 5 job title and company size combinations:
Larger companies have higher median salaries for Product Manager and smaller companies have higher median salaries for Software Engineers.
Illustration ▼
Among the combinations of the top 5 normalized job titles and top 5 industries the ranking of the highest median reported salaries is as follows:
Illustration ▼
Based on the job listings, the companies with up to 200 employees in the Internet Industry are looking especially for Software Engineers in Berlin.
Smaller companies have higher median base salaries for Software Engineers compared to larger companies. The median base salary is between 33,000 and 58,000 Euro.
The highest median base salaries with approx. 72,000 Euro have been reported for Product Managers of companies with more than 10,000 employees. Product Manager in Internet industry have a median salary of roughly 82,000 Euro.
Product Manager jobs are listed in companies with the companies with up to 200 employees or with more than 10000 employees in the Internet industry in Berlin as well as in München.
The examination relies on the dataset provided by André Sionek on Kaggle. The information provided on Kaggle and the GitHub repository states how the data was scraped and prepared. The data was scraped on the 10th of December 2019 from Glassdoor. The data is available under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International Public License (CC BY-NC-SA 4.0). This data analysis project was done for personal educational purposes only. The author does not have any connection to Glassdoor.